Profiling Report

Dataset statistics

Number of variables	24
Number of observations	55314
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	9.9 MiB
Average record size in memory	188.0 B

Variable types

Categorical	4
Numeric	19
Text	1

Alerts

`season` has constant value ""	Constant
`club_id` is highly overall correlated with `league_id` and 2 other fields	High correlation
`league_id` is highly overall correlated with `club_id` and 3 other fields	High correlation
`cohort_season` is highly overall correlated with `club_id` and 2 other fields	High correlation
`avg_stars_top_11_players` is highly overall correlated with `league_id` and 8 other fields	High correlation
`avg_stars_top_14_players` is highly overall correlated with `league_id` and 8 other fields	High correlation
`days_active_last_28_days` is highly overall correlated with `avg_stars_top_11_players` and 9 other fields	High correlation
`league_match_watched_count_last_28_days` is highly overall correlated with `avg_stars_top_11_players` and 9 other fields	High correlation
`session_count_last_28_days` is highly overall correlated with `avg_stars_top_11_players` and 9 other fields	High correlation
`playtime_last_28_days` is highly overall correlated with `avg_stars_top_11_players` and 9 other fields	High correlation
`league_match_won_count_last_28_days` is highly overall correlated with `days_active_last_28_days` and 4 other fields	High correlation
`training_count_last_28_days` is highly overall correlated with `avg_stars_top_11_players` and 9 other fields	High correlation
`global_competition_level` is highly overall correlated with `club_id` and 9 other fields	High correlation
`tokens_spent_last_28_days` is highly overall correlated with `avg_stars_top_11_players` and 7 other fields	High correlation
`rests_stash` is highly overall correlated with `morale_boosters_stash`	High correlation
`morale_boosters_stash` is highly overall correlated with `rests_stash`	High correlation
`league_rank` is highly overall correlated with `days_active_last_28_days` and 4 other fields	High correlation
`registration_platform_specific` is highly imbalanced (51.4%)	Imbalance
`tokens_spent_last_28_days` is highly skewed (γ1 = 75.32770805)	Skewed
`tokens_stash` is highly skewed (γ1 = 230.8711493)	Skewed
`club_id` has unique values	Unique
`avg_training_factor_top_11_players` has unique values	Unique
`days_active_last_28_days` has 13005 (23.5%) zeros	Zeros
`league_match_watched_count_last_28_days` has 29504 (53.3%) zeros	Zeros
`session_count_last_28_days` has 13029 (23.6%) zeros	Zeros
`playtime_last_28_days` has 13029 (23.6%) zeros	Zeros
`training_count_last_28_days` has 19207 (34.7%) zeros	Zeros
`global_competition_level` has 17551 (31.7%) zeros	Zeros
`tokens_spent_last_28_days` has 18799 (34.0%) zeros	Zeros
`tokens_stash` has 1087 (2.0%) zeros	Zeros

Reproduction

Analysis started	2023-11-19 15:54:47.701388
Analysis finished	2023-11-19 15:57:50.107456
Duration	3 minutes and 2.41 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

season
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.3 KiB

173	55314

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	165942
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	173
2nd row	173
3rd row	173
4th row	173
5th row	173

Common Values

Value	Count	Frequency (%)
173	55314	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
173	55314	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	55314	33.3%
7	55314	33.3%
3	55314	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	165942	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	55314	33.3%
7	55314	33.3%
3	55314	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	165942	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	55314	33.3%
7	55314	33.3%
3	55314	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	165942	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	55314	33.3%
7	55314	33.3%
3	55314	33.3%

club_id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	55314
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12109765

Minimum	275
Maximum	14514770
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	275
5-th percentile	5993755.9
Q1	11511047
median	13928216
Q3	14244540
95-th percentile	14409146
Maximum	14514770
Range	14514495
Interquartile range (IQR)	2733492.5

Descriptive statistics

Standard deviation	3384016.2
Coefficient of variation (CV)	0.27944523
Kurtosis	1.6704162
Mean	12109765
Median Absolute Deviation (MAD)	439454.5
Skewness	-1.6330064
Sum	6.6983956 × 10¹¹
Variance	1.1451566 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6042825	1	< 0.1%
14347346	1	< 0.1%
6044120	1	< 0.1%
13607777	1	< 0.1%
14195413	1	< 0.1%
13991054	1	< 0.1%
11852863	1	< 0.1%
14166575	1	< 0.1%
6032412	1	< 0.1%
13712821	1	< 0.1%
Other values (55304)	55304	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
275	1	< 0.1%
16371	1	< 0.1%
22726	1	< 0.1%
27248	1	< 0.1%
43766	1	< 0.1%
48258	1	< 0.1%
68761	1	< 0.1%
110893	1	< 0.1%
120096	1	< 0.1%
121182	1	< 0.1%

Value	Count	Frequency (%)
14514770	1	< 0.1%
14514423	1	< 0.1%
14514347	1	< 0.1%
14513703	1	< 0.1%
14513382	1	< 0.1%
14513043	1	< 0.1%
14513001	1	< 0.1%
14512908	1	< 0.1%
14512802	1	< 0.1%
14512708	1	< 0.1%

league_id
Real number (ℝ)

HIGH CORRELATION

Distinct	3951
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2909804.2

Minimum	2904743
Maximum	2912940
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	2904743
5-th percentile	2906496
Q1	2907961
median	2910038
Q3	2911697
95-th percentile	2912729
Maximum	2912940
Range	8197
Interquartile range (IQR)	3736

Descriptive statistics

Standard deviation	2102.1399
Coefficient of variation (CV)	0.00072243346
Kurtosis	-1.2026611
Mean	2909804.2
Median Absolute Deviation (MAD)	1825
Skewness	-0.22744403
Sum	1.6095291 × 10¹¹
Variance	4418992.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2912348	14	< 0.1%
2908518	14	< 0.1%
2912576	14	< 0.1%
2910101	14	< 0.1%
2911527	14	< 0.1%
2911848	14	< 0.1%
2907339	14	< 0.1%
2911991	14	< 0.1%
2912455	14	< 0.1%
2912312	14	< 0.1%
Other values (3941)	55174	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2904743	14	< 0.1%
2904844	14	< 0.1%
2904897	14	< 0.1%
2904917	14	< 0.1%
2905007	14	< 0.1%
2905169	14	< 0.1%
2905175	14	< 0.1%
2905181	14	< 0.1%
2905225	14	< 0.1%
2905228	14	< 0.1%

Value	Count	Frequency (%)
2912940	14	< 0.1%
2912939	14	< 0.1%
2912938	14	< 0.1%
2912936	14	< 0.1%
2912935	14	< 0.1%
2912934	14	< 0.1%
2912933	14	< 0.1%
2912932	14	< 0.1%
2912931	14	< 0.1%
2912930	14	< 0.1%

dynamic_payment_segment
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.3 KiB

0) NonPayer	41843
2) Minnow	6047
1) ExPayer	5025
3) Dolphin	1854
4) Whale	545

Length

Max length	11
Median length	11
Mean length	10.627436
Min length	8

Characters and Unicode

Total characters	587846
Distinct characters	25
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2) Minnow
2nd row	2) Minnow
3rd row	4) Whale
4th row	0) NonPayer
5th row	0) NonPayer

Common Values

Value	Count	Frequency (%)
0) NonPayer	41843	75.6%
2) Minnow	6047	10.9%
1) ExPayer	5025	9.1%
3) Dolphin	1854	3.4%
4) Whale	545	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	41843	37.8%
nonpayer	41843	37.8%
2	6047	5.5%
minnow	6047	5.5%
1	5025	4.5%
expayer	5025	4.5%
3	1854	1.7%
dolphin	1854	1.7%
4	545	0.5%
whale	545	0.5%

Most occurring characters

Value	Count	Frequency (%)
n	55791	9.5%
	55314	9.4%
)	55314	9.4%
o	49744	8.5%
a	47413	8.1%
e	47413	8.1%
P	46868	8.0%
y	46868	8.0%
r	46868	8.0%
0	41843	7.1%
Other values (15)	94410	16.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	319722	54.4%
Uppercase Letter	102182	17.4%
Space Separator	55314	9.4%
Close Punctuation	55314	9.4%
Decimal Number	55314	9.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	55791	17.4%
o	49744	15.6%
a	47413	14.8%
e	47413	14.8%
y	46868	14.7%
r	46868	14.7%
i	7901	2.5%
w	6047	1.9%
x	5025	1.6%
l	2399	0.8%
Other values (2)	4253	1.3%

Uppercase Letter

Value	Count	Frequency (%)
P	46868	45.9%
N	41843	40.9%
M	6047	5.9%
E	5025	4.9%
D	1854	1.8%
W	545	0.5%

Decimal Number

Value	Count	Frequency (%)
0	41843	75.6%
2	6047	10.9%
1	5025	9.1%
3	1854	3.4%
4	545	1.0%

Space Separator

Value	Count	Frequency (%)
	55314	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	55314	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	421904	71.8%
Common	165942	28.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	55791	13.2%
o	49744	11.8%
a	47413	11.2%
e	47413	11.2%
P	46868	11.1%
y	46868	11.1%
r	46868	11.1%
N	41843	9.9%
i	7901	1.9%
w	6047	1.4%
Other values (8)	25148	6.0%

Common

Value	Count	Frequency (%)
	55314	33.3%
)	55314	33.3%
0	41843	25.2%
2	6047	3.6%
1	5025	3.0%
3	1854	1.1%
4	545	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	587846	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	55791	9.5%
	55314	9.4%
)	55314	9.4%
o	49744	8.5%
a	47413	8.1%
e	47413	8.1%
P	46868	8.0%
y	46868	8.0%
r	46868	8.0%
0	41843	7.1%
Other values (15)	94410	16.1%

cohort_season
Real number (ℝ)

HIGH CORRELATION

Distinct	172
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.409372

Minimum	1
Maximum	172
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	17
95-th percentile	135
Maximum	172
Range	171
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	42.009274
Coefficient of variation (CV)	1.7945494
Kurtosis	3.2492578
Mean	23.409372
Median Absolute Deviation (MAD)	3
Skewness	2.1340015
Sum	1294866
Variance	1764.7791
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	12333	22.3%
1	8529	15.4%
3	6409	11.6%
4	3320	6.0%
5	2014	3.6%
6	1452	2.6%
7	1204	2.2%
8	1020	1.8%
11	817	1.5%
12	801	1.4%
Other values (162)	17415	31.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	8529	15.4%
2	12333	22.3%
3	6409	11.6%
4	3320	6.0%
5	2014	3.6%
6	1452	2.6%
7	1204	2.2%
8	1020	1.8%
9	793	1.4%
10	713	1.3%

Value	Count	Frequency (%)
172	27	< 0.1%
171	32	0.1%
170	49	0.1%
169	46	0.1%
168	23	< 0.1%
167	58	0.1%
166	100	0.2%
165	50	0.1%
164	45	0.1%
163	66	0.1%

avg_age_top_11_players
Real number (ℝ)

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.718661

Minimum	18
Maximum	33
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	18
5-th percentile	21
Q1	22
median	23
Q3	25
95-th percentile	28
Maximum	33
Range	15
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2062402
Coefficient of variation (CV)	0.093017065
Kurtosis	1.8597279
Mean	23.718661
Median Absolute Deviation (MAD)	1
Skewness	0.96748057
Sum	1311974
Variance	4.8674959
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
23	11528	20.8%
24	10856	19.6%
22	9102	16.5%
25	7455	13.5%
21	5023	9.1%
26	4028	7.3%
27	2091	3.8%
20	1851	3.3%
28	1079	2.0%
29	627	1.1%
Other values (6)	1674	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18	16	< 0.1%
19	345	0.6%
20	1851	3.3%
21	5023	9.1%
22	9102	16.5%
23	11528	20.8%
24	10856	19.6%
25	7455	13.5%
26	4028	7.3%
27	2091	3.8%

Value	Count	Frequency (%)
33	165	0.3%
32	254	0.5%
31	348	0.6%
30	546	1.0%
29	627	1.1%
28	1079	2.0%
27	2091	3.8%
26	4028	7.3%
25	7455	13.5%
24	10856	19.6%

avg_stars_top_11_players
Real number (ℝ)

HIGH CORRELATION

Distinct	55260
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5335157

Minimum	1.451697
Maximum	23.716073
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	1.451697
5-th percentile	2.7761788
Q1	3.6911364
median	4.4813758
Q3	5.2173939
95-th percentile	6.6650405
Maximum	23.716073
Range	22.264376
Interquartile range (IQR)	1.5262575

Descriptive statistics

Standard deviation	1.2047528
Coefficient of variation (CV)	0.26574361
Kurtosis	2.7556137
Mean	4.5335157
Median Absolute Deviation (MAD)	0.76335147
Skewness	0.69560239
Sum	250766.89
Variance	1.4514294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.277163632	2	< 0.1%
4.377672734	2	< 0.1%
4.429527255	2	< 0.1%
4.627006115	2	< 0.1%
4.370133316	2	< 0.1%
3.710533318	2	< 0.1%
4.577648519	2	< 0.1%
4.841284864	2	< 0.1%
3.749309091	2	< 0.1%
2.775151512	2	< 0.1%
Other values (55250)	55294	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.451696972	1	< 0.1%
1.831236363	1	< 0.1%
1.854957567	1	< 0.1%
1.865236365	1	< 0.1%
1.876206067	1	< 0.1%
1.896557572	1	< 0.1%
1.899745441	1	< 0.1%
1.901660603	1	< 0.1%
1.904569691	1	< 0.1%
1.906545455	1	< 0.1%

Value	Count	Frequency (%)
23.71607281	1	< 0.1%
20.13309084	1	< 0.1%
17.55141809	1	< 0.1%
16.25966042	1	< 0.1%
14.95066665	1	< 0.1%
14.65561202	1	< 0.1%
14.54728492	1	< 0.1%
13.11088482	1	< 0.1%
11.32044811	1	< 0.1%
11.10578199	1	< 0.1%

avg_stars_top_14_players
Real number (ℝ)

HIGH CORRELATION

Distinct	55282
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.3447756

Minimum	1.3549048
Maximum	20.434876
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	1.3549048
5-th percentile	2.6438814
Q1	3.5000619
median	4.3115905
Q3	5.0217262
95-th percentile	6.4125831
Maximum	20.434876
Range	19.079971
Interquartile range (IQR)	1.5216643

Descriptive statistics

Standard deviation	1.1770682
Coefficient of variation (CV)	0.27091575
Kurtosis	1.8476815
Mean	4.3447756
Median Absolute Deviation (MAD)	0.75753812
Skewness	0.62752189
Sum	240326.92
Variance	1.3854894
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.127152376	2	< 0.1%
2.958314287	2	< 0.1%
3.725733316	2	< 0.1%
4.907609544	2	< 0.1%
2.837742855	2	< 0.1%
2.683171424	2	< 0.1%
3.900600006	2	< 0.1%
4.866428586	2	< 0.1%
4.236361914	2	< 0.1%
2.791199997	2	< 0.1%
Other values (55272)	55294	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.354904763	1	< 0.1%
1.717933317	1	< 0.1%
1.746590481	1	< 0.1%
1.752380952	1	< 0.1%
1.758390477	1	< 0.1%
1.762361903	1	< 0.1%
1.768742851	1	< 0.1%
1.769571429	1	< 0.1%
1.778276186	1	< 0.1%
1.793047624	1	< 0.1%

Value	Count	Frequency (%)
20.43487619	1	< 0.1%
17.90579995	1	< 0.1%
15.90664743	1	< 0.1%
14.71906657	1	< 0.1%
14.43303814	1	< 0.1%
13.66381894	1	< 0.1%
12.56584757	1	< 0.1%
12.42757141	1	< 0.1%
10.80125686	1	< 0.1%
10.51113339	1	< 0.1%

avg_training_factor_top_11_players
Real number (ℝ)

UNIQUE

Distinct	55314
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.58437182

Minimum	-1.2877365
Maximum	5.1644943
Zeros	0
Zeros (%)	0.0%
Negative	132
Negative (%)	0.2%
Memory size	432.3 KiB

Quantile statistics

Minimum	-1.2877365
5-th percentile	0.39617839
Q1	0.47957092
median	0.56115796
Q3	0.64817985
95-th percentile	0.90088122
Maximum	5.1644943
Range	6.4522308
Interquartile range (IQR)	0.16860893

Descriptive statistics

Standard deviation	0.17808997
Coefficient of variation (CV)	0.30475455
Kurtosis	39.805591
Mean	0.58437182
Median Absolute Deviation (MAD)	0.083941911
Skewness	3.1056679
Sum	32323.943
Variance	0.031716038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.778801246	1	< 0.1%
0.4269814922	1	< 0.1%
0.5223622933	1	< 0.1%
0.7602145878	1	< 0.1%
0.514817867	1	< 0.1%
0.6951656966	1	< 0.1%
0.6121318988	1	< 0.1%
0.4347173591	1	< 0.1%
0.438736348	1	< 0.1%
0.5855279554	1	< 0.1%
Other values (55304)	55304	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1.287736497	1	< 0.1%
-0.8862160754	1	< 0.1%
-0.8436819335	1	< 0.1%
-0.8364241275	1	< 0.1%
-0.7575517528	1	< 0.1%
-0.7369245558	1	< 0.1%
-0.7369205118	1	< 0.1%
-0.7149970649	1	< 0.1%
-0.6670450834	1	< 0.1%
-0.6630123572	1	< 0.1%

Value	Count	Frequency (%)
5.164494312	1	< 0.1%
4.834535193	1	< 0.1%
3.999635499	1	< 0.1%
3.875257411	1	< 0.1%
3.562516136	1	< 0.1%
3.550029568	1	< 0.1%
3.364479495	1	< 0.1%
3.311070816	1	< 0.1%
3.253493218	1	< 0.1%
3.182084713	1	< 0.1%

days_active_last_28_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	29
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.357089

Minimum	0
Maximum	28
Zeros	13005
Zeros (%)	23.5%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	7
Q3	27
95-th percentile	28
Maximum	28
Range	28
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	11.849102
Coefficient of variation (CV)	0.95889109
Kurtosis	-1.7083818
Mean	12.357089
Median Absolute Deviation (MAD)	7
Skewness	0.27544921
Sum	683520
Variance	140.40122
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	13005	23.5%
28	11952	21.6%
1	5064	9.2%
2	2961	5.4%
27	2603	4.7%
3	1993	3.6%
26	1551	2.8%
4	1529	2.8%
5	1224	2.2%
25	1157	2.1%
Other values (19)	12275	22.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13005	23.5%
1	5064	9.2%
2	2961	5.4%
3	1993	3.6%
4	1529	2.8%
5	1224	2.2%
6	1017	1.8%
7	872	1.6%
8	790	1.4%
9	732	1.3%

Value	Count	Frequency (%)
28	11952	21.6%
27	2603	4.7%
26	1551	2.8%
25	1157	2.1%
24	877	1.6%
23	770	1.4%
22	656	1.2%
21	625	1.1%
20	566	1.0%
19	547	1.0%

league_match_watched_count_last_28_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.6231695

Minimum	0
Maximum	26
Zeros	29504
Zeros (%)	53.3%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5
95-th percentile	18
Maximum	26
Range	26
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	5.9060546
Coefficient of variation (CV)	1.6300796
Kurtosis	2.1572043
Mean	3.6231695
Median Absolute Deviation (MAD)	0
Skewness	1.7593748
Sum	200412
Variance	34.881481
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	29504	53.3%
1	4759	8.6%
2	2790	5.0%
3	2007	3.6%
4	1642	3.0%
5	1390	2.5%
6	1287	2.3%
7	1087	2.0%
8	1046	1.9%
9	983	1.8%
Other values (17)	8819	15.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	29504	53.3%
1	4759	8.6%
2	2790	5.0%
3	2007	3.6%
4	1642	3.0%
5	1390	2.5%
6	1287	2.3%
7	1087	2.0%
8	1046	1.9%
9	983	1.8%

Value	Count	Frequency (%)
26	64	0.1%
25	137	0.2%
24	218	0.4%
23	271	0.5%
22	299	0.5%
21	389	0.7%
20	434	0.8%
19	497	0.9%
18	566	1.0%
17	575	1.0%

session_count_last_28_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	732
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.432169

Minimum	0
Maximum	1365
Zeros	13029
Zeros (%)	23.6%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	16
Q3	89
95-th percentile	263
Maximum	1365
Range	1365
Interquartile range (IQR)	88

Descriptive statistics

Standard deviation	101.83167
Coefficient of variation (CV)	1.6053632
Kurtosis	14.254607
Mean	63.432169
Median Absolute Deviation (MAD)	16
Skewness	2.9778055
Sum	3508687
Variance	10369.689
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13029	23.6%
1	3457	6.2%
2	2196	4.0%
3	1406	2.5%
4	1156	2.1%
5	925	1.7%
6	818	1.5%
7	702	1.3%
8	627	1.1%
9	563	1.0%
Other values (722)	30435	55.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13029	23.6%
1	3457	6.2%
2	2196	4.0%
3	1406	2.5%
4	1156	2.1%
5	925	1.7%
6	818	1.5%
7	702	1.3%
8	627	1.1%
9	563	1.0%

Value	Count	Frequency (%)
1365	1	< 0.1%
1342	1	< 0.1%
1291	1	< 0.1%
1279	1	< 0.1%
1275	1	< 0.1%
1188	1	< 0.1%
1173	1	< 0.1%
1162	1	< 0.1%
1158	1	< 0.1%
1127	1	< 0.1%

playtime_last_28_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	42244
Distinct (%)	76.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29551777

Minimum	0
Maximum	1.3404787 × 10⁹
Zeros	13029
Zeros (%)	23.6%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	73641.5
median	6230431
Q3	37687108
95-th percentile	1.3119349 × 10⁸
Maximum	1.3404787 × 10⁹
Range	1.3404787 × 10⁹
Interquartile range (IQR)	37613466

Descriptive statistics

Standard deviation	52338916
Coefficient of variation (CV)	1.771092
Kurtosis	33.917358
Mean	29551777
Median Absolute Deviation (MAD)	6230431
Skewness	3.9566874
Sum	1.634627 × 10¹²
Variance	2.7393622 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13029	23.6%
104338	2	< 0.1%
1158639	2	< 0.1%
6833560	2	< 0.1%
7829149	2	< 0.1%
1262716	2	< 0.1%
1313074	2	< 0.1%
36397933	2	< 0.1%
543178	2	< 0.1%
329955	2	< 0.1%
Other values (42234)	42267	76.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13029	23.6%
894	1	< 0.1%
2103	1	< 0.1%
2569	2	< 0.1%
2633	1	< 0.1%
2658	1	< 0.1%
2706	1	< 0.1%
2790	1	< 0.1%
3059	1	< 0.1%
3085	1	< 0.1%

Value	Count	Frequency (%)
1340478682	1	< 0.1%
1310266523	1	< 0.1%
884749571	1	< 0.1%
859296125	1	< 0.1%
775760071	1	< 0.1%
766103461	1	< 0.1%
703368228	1	< 0.1%
700369247	1	< 0.1%
674335478	1	< 0.1%
673310929	1	< 0.1%

registration_country
Text

Distinct	186
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	432.3 KiB

Length

Max length	37
Median length	28
Mean length	7.9717612
Min length	4

Characters and Unicode

Total characters	440950
Distinct characters	54
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	< 0.1%

Sample

1st row	Portugal
2nd row	Turkey
3rd row	Belgium
4th row	Malaysia
5th row	Italy

Value	Count	Frequency (%)
indonesia	9830	15.7%
turkey	4563	7.3%
brazil	3080	4.9%
united	3055	4.9%
germany	2722	4.4%
france	2144	3.4%
thailand	2096	3.4%
kingdom	1924	3.1%
italy	1872	3.0%
serbia	1589	2.5%
Other values (208)	29664	47.4%

Most occurring characters

Value	Count	Frequency (%)
a	55535	12.6%
n	47181	10.7%
e	41654	9.4%
i	39382	8.9%
r	25656	5.8%
d	22354	5.1%
o	22319	5.1%
s	16204	3.7%
l	16030	3.6%
t	13416	3.0%
Other values (44)	141219	32.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	371690	84.3%
Uppercase Letter	61628	14.0%
Space Separator	7225	1.6%
Other Punctuation	406	0.1%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	55535	14.9%
n	47181	12.7%
e	41654	11.2%
i	39382	10.6%
r	25656	6.9%
d	22354	6.0%
o	22319	6.0%
s	16204	4.4%
l	16030	4.3%
t	13416	3.6%
Other values (16)	71959	19.4%

Uppercase Letter

Value	Count	Frequency (%)
I	13149	21.3%
T	7004	11.4%
S	5908	9.6%
B	4718	7.7%
G	4103	6.7%
U	3695	6.0%
A	2875	4.7%
F	2722	4.4%
R	2572	4.2%
P	2565	4.2%
Other values (14)	12317	20.0%

Other Punctuation

Value	Count	Frequency (%)
,	301	74.1%
'	105	25.9%

Space Separator

Value	Count	Frequency (%)
	7225	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	433318	98.3%
Common	7632	1.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	55535	12.8%
n	47181	10.9%
e	41654	9.6%
i	39382	9.1%
r	25656	5.9%
d	22354	5.2%
o	22319	5.2%
s	16204	3.7%
l	16030	3.7%
t	13416	3.1%
Other values (40)	133587	30.8%

Common

Value	Count	Frequency (%)
	7225	94.7%
,	301	3.9%
'	105	1.4%
-	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	440950	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	55535	12.6%
n	47181	10.7%
e	41654	9.4%
i	39382	8.9%
r	25656	5.8%
d	22354	5.1%
o	22319	5.1%
s	16204	3.7%
l	16030	3.6%
t	13416	3.0%
Other values (44)	141219	32.0%

registration_platform_specific
Categorical

IMBALANCE

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.3 KiB

Android Phone	35859
iOS Phone	9896
Flash FB Canvas	4340
Android Tablet	1867
iOS Tablet	1214
Other values (6)	2138

Length

Max length	24
Median length	13
Mean length	12.541545
Min length	9

Characters and Unicode

Total characters	693723
Distinct characters	28
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Flash FB Canvas
2nd row	Android Phone
3rd row	Flash FB Canvas
4th row	Android Phone
5th row	iOS Phone

Common Values

Value	Count	Frequency (%)
Android Phone	35859	64.8%
iOS Phone	9896	17.9%
Flash FB Canvas	4340	7.8%
Android Tablet	1867	3.4%
iOS Tablet	1214	2.2%
UniversalWindows PC	724	1.3%
WebGL FB Canvas	702	1.3%
WebGL TE Site	489	0.9%
WebGL or Flash FB Canvas	129	0.2%
Flash TE Site	77	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
phone	45755	39.2%
android	37726	32.3%
ios	11110	9.5%
fb	5171	4.4%
canvas	5171	4.4%
flash	4563	3.9%
tablet	3081	2.6%
webgl	1337	1.1%
universalwindows	724	0.6%
pc	724	0.6%
Other values (3)	1312	1.1%

Most occurring characters

Value	Count	Frequency (%)
n	90100	13.0%
o	84351	12.2%
d	76176	11.0%
	61360	8.8%
e	51480	7.4%
i	50867	7.3%
h	50318	7.3%
P	46479	6.7%
r	38596	5.6%
A	37726	5.4%
Other values (18)	106270	15.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	494849	71.3%
Uppercase Letter	137514	19.8%
Space Separator	61360	8.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	90100	18.2%
o	84351	17.0%
d	76176	15.4%
e	51480	10.4%
i	50867	10.3%
h	50318	10.2%
r	38596	7.8%
a	18710	3.8%
s	11182	2.3%
l	8368	1.7%
Other values (4)	14701	3.0%

Uppercase Letter

Value	Count	Frequency (%)
P	46479	33.8%
A	37726	27.4%
S	11693	8.5%
O	11110	8.1%
F	9734	7.1%
C	5895	4.3%
B	5171	3.8%
T	3664	2.7%
W	2061	1.5%
G	1337	1.0%
Other values (3)	2644	1.9%

Space Separator

Value	Count	Frequency (%)
	61360	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	632363	91.2%
Common	61360	8.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	90100	14.2%
o	84351	13.3%
d	76176	12.0%
e	51480	8.1%
i	50867	8.0%
h	50318	8.0%
P	46479	7.4%
r	38596	6.1%
A	37726	6.0%
a	18710	3.0%
Other values (17)	87560	13.8%

Common

Value	Count	Frequency (%)
	61360	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	693723	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	90100	13.0%
o	84351	12.2%
d	76176	11.0%
	61360	8.8%
e	51480	7.4%
i	50867	7.3%
h	50318	7.3%
P	46479	6.7%
r	38596	5.6%
A	37726	5.4%
Other values (18)	106270	15.3%

league_match_won_count_last_28_days
Real number (ℝ)

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.411813

Minimum	0
Maximum	26
Zeros	410
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	8
median	12
Q3	17
95-th percentile	24
Maximum	26
Range	26
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.4030132
Coefficient of variation (CV)	0.51588059
Kurtosis	-0.81988192
Mean	12.411813
Median Absolute Deviation (MAD)	5
Skewness	0.26602051
Sum	686547
Variance	40.998578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
9	3639	6.6%
10	3578	6.5%
8	3411	6.2%
11	3261	5.9%
12	3016	5.5%
7	2988	5.4%
13	2672	4.8%
6	2650	4.8%
14	2395	4.3%
5	2240	4.0%
Other values (17)	25464	46.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	410	0.7%
1	799	1.4%
2	1257	2.3%
3	1507	2.7%
4	1786	3.2%
5	2240	4.0%
6	2650	4.8%
7	2988	5.4%
8	3411	6.2%
9	3639	6.6%

Value	Count	Frequency (%)
26	715	1.3%
25	1040	1.9%
24	1254	2.3%
23	1526	2.8%
22	1609	2.9%
21	1777	3.2%
20	1785	3.2%
19	1828	3.3%
18	1927	3.5%
17	2049	3.7%

training_count_last_28_days
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1171
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.107694

Minimum	0
Maximum	7443
Zeros	19207
Zeros (%)	34.7%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	11
Q3	63
95-th percentile	215
Maximum	7443
Range	7443
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	188.28828
Coefficient of variation (CV)	3.0812533
Kurtosis	210.51782
Mean	61.107694
Median Absolute Deviation (MAD)	11
Skewness	11.300982
Sum	3380111
Variance	35452.478
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19207	34.7%
1	1496	2.7%
2	1220	2.2%
3	1073	1.9%
4	900	1.6%
5	741	1.3%
6	706	1.3%
8	596	1.1%
7	586	1.1%
9	580	1.0%
Other values (1161)	28209	51.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	19207	34.7%
1	1496	2.7%
2	1220	2.2%
3	1073	1.9%
4	900	1.6%
5	741	1.3%
6	706	1.3%
7	586	1.1%
8	596	1.1%
9	580	1.0%

Value	Count	Frequency (%)
7443	1	< 0.1%
6866	1	< 0.1%
5349	1	< 0.1%
4943	1	< 0.1%
4883	1	< 0.1%
4795	1	< 0.1%
4607	1	< 0.1%
4130	1	< 0.1%
4078	1	< 0.1%
3917	1	< 0.1%

global_competition_level
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.6632317

Minimum	0
Maximum	11
Zeros	17551
Zeros (%)	31.7%
Negative	0
Negative (%)	0.0%
Memory size	216.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	5
95-th percentile	8
Maximum	11
Range	11
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.8289278
Coefficient of variation (CV)	1.0622162
Kurtosis	-0.51547738
Mean	2.6632317
Median Absolute Deviation (MAD)	1
Skewness	0.8380647
Sum	147314
Variance	8.0028326
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	17551	31.7%
1	10389	18.8%
2	4898	8.9%
3	3965	7.2%
5	3701	6.7%
6	3651	6.6%
7	3458	6.3%
4	3409	6.2%
8	2374	4.3%
9	1327	2.4%
Other values (2)	591	1.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17551	31.7%
1	10389	18.8%
2	4898	8.9%
3	3965	7.2%
4	3409	6.2%
5	3701	6.7%
6	3651	6.6%
7	3458	6.3%
8	2374	4.3%
9	1327	2.4%

Value	Count	Frequency (%)
11	136	0.2%
10	455	0.8%
9	1327	2.4%
8	2374	4.3%
7	3458	6.3%
6	3651	6.6%
5	3701	6.7%
4	3409	6.2%
3	3965	7.2%
2	4898	8.9%

tokens_spent_last_28_days
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	1530
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	121.3939

Minimum	0
Maximum	120233
Zeros	18799
Zeros (%)	34.0%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	38
Q3	107
95-th percentile	361
Maximum	120233
Range	120233
Interquartile range (IQR)	107

Descriptive statistics

Standard deviation	842.77553
Coefficient of variation (CV)	6.9424868
Kurtosis	8938.5575
Mean	121.3939
Median Absolute Deviation (MAD)	38
Skewness	75.327708
Sum	6714782
Variance	710270.59
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	18799	34.0%
5	712	1.3%
2	526	1.0%
10	386	0.7%
20	336	0.6%
15	278	0.5%
50	275	0.5%
25	264	0.5%
13	261	0.5%
4	259	0.5%
Other values (1520)	33218	60.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18799	34.0%
1	158	0.3%
2	526	1.0%
3	244	0.4%
4	259	0.5%
5	712	1.3%
6	258	0.5%
7	209	0.4%
8	239	0.4%
9	204	0.4%

Value	Count	Frequency (%)
120233	1	< 0.1%
76236	1	< 0.1%
37698	1	< 0.1%
33731	1	< 0.1%
28382	1	< 0.1%
27111	1	< 0.1%
26207	1	< 0.1%
25805	1	< 0.1%
25169	1	< 0.1%
23180	1	< 0.1%

tokens_stash
Real number (ℝ)

SKEWED ZEROS

Distinct	1642
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	113.13308

Minimum	-4975
Maximum	744202
Zeros	1087
Zeros (%)	2.0%
Negative	8
Negative (%)	< 0.1%
Memory size	432.3 KiB

Quantile statistics

Minimum	-4975
5-th percentile	2
Q1	11
median	29
Q3	73
95-th percentile	352
Maximum	744202
Range	749177
Interquartile range (IQR)	62

Descriptive statistics

Standard deviation	3183.5504
Coefficient of variation (CV)	28.139873
Kurtosis	53957.111
Mean	113.13308
Median Absolute Deviation (MAD)	22
Skewness	230.87115
Sum	6257843
Variance	10134993
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	1288	2.3%
10	1282	2.3%
4	1221	2.2%
7	1199	2.2%
11	1185	2.1%
3	1177	2.1%
8	1138	2.1%
5	1133	2.0%
6	1114	2.0%
2	1111	2.0%
Other values (1632)	43466	78.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4975	1	< 0.1%
-629	1	< 0.1%
-391	1	< 0.1%
-342	2	< 0.1%
-275	1	< 0.1%
-196	1	< 0.1%
-10	1	< 0.1%
0	1087	2.0%
1	1021	1.8%
2	1111	2.0%

Value	Count	Frequency (%)
744202	1	< 0.1%
20424	1	< 0.1%
16750	1	< 0.1%
14375	1	< 0.1%
12705	1	< 0.1%
12252	1	< 0.1%
10711	1	< 0.1%
10684	1	< 0.1%
9942	1	< 0.1%
7345	1	< 0.1%

rests_stash
Real number (ℝ)

HIGH CORRELATION

Distinct	2686
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	283.08352

Minimum	-169
Maximum	32767
Zeros	514
Zeros (%)	0.9%
Negative	1
Negative (%)	< 0.1%
Memory size	432.3 KiB

Quantile statistics

Minimum	-169
5-th percentile	8
Q1	41
median	88
Q3	243
95-th percentile	1054
Maximum	32767
Range	32936
Interquartile range (IQR)	202

Descriptive statistics

Standard deviation	789.25096
Coefficient of variation (CV)	2.7880498
Kurtosis	319.29357
Mean	283.08352
Median Absolute Deviation (MAD)	65
Skewness	13.034028
Sum	15658482
Variance	622917.08
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42	1216	2.2%
43	1007	1.8%
0	514	0.9%
52	504	0.9%
44	499	0.9%
45	449	0.8%
3	417	0.8%
24	401	0.7%
46	400	0.7%
53	398	0.7%
Other values (2676)	49509	89.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-169	1	< 0.1%
0	514	0.9%
1	155	0.3%
2	146	0.3%
3	417	0.8%
4	295	0.5%
5	280	0.5%
6	298	0.5%
7	376	0.7%
8	314	0.6%

Value	Count	Frequency (%)
32767	1	< 0.1%
32553	1	< 0.1%
32185	1	< 0.1%
30757	1	< 0.1%
27677	1	< 0.1%
23232	1	< 0.1%
20725	1	< 0.1%
19436	1	< 0.1%
18012	1	< 0.1%
17908	1	< 0.1%

morale_boosters_stash
Real number (ℝ)

HIGH CORRELATION

Distinct	2805
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	307.08596

Minimum	0
Maximum	32767
Zeros	313
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	52
median	118
Q3	281
95-th percentile	1116
Maximum	32767
Range	32767
Interquartile range (IQR)	229

Descriptive statistics

Standard deviation	823.36249
Coefficient of variation (CV)	2.6812117
Kurtosis	524.00294
Mean	307.08596
Median Absolute Deviation (MAD)	82
Skewness	17.344588
Sum	16986153
Variance	677925.78
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39	360	0.7%
40	354	0.6%
42	336	0.6%
38	333	0.6%
37	331	0.6%
50	322	0.6%
44	322	0.6%
51	321	0.6%
36	318	0.6%
53	318	0.6%
Other values (2795)	51999	94.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	313	0.6%
1	208	0.4%
2	214	0.4%
3	176	0.3%
4	204	0.4%
5	183	0.3%
6	195	0.4%
7	190	0.3%
8	225	0.4%
9	193	0.3%

Value	Count	Frequency (%)
32767	2	< 0.1%
32765	2	< 0.1%
32758	1	< 0.1%
32713	1	< 0.1%
32587	1	< 0.1%
32451	1	< 0.1%
31583	1	< 0.1%
26076	1	< 0.1%
25496	1	< 0.1%
24982	1	< 0.1%

league_rank
Real number (ℝ)

HIGH CORRELATION

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.5

Minimum	1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	432.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7.5
Q3	11
95-th percentile	14
Maximum	14
Range	13
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.0311653
Coefficient of variation (CV)	0.53748871
Kurtosis	-1.2123088
Mean	7.5
Median Absolute Deviation (MAD)	3.5
Skewness	0
Sum	414855
Variance	16.250294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2	3951	7.1%
1	3951	7.1%
6	3951	7.1%
10	3951	7.1%
12	3951	7.1%
7	3951	7.1%
5	3951	7.1%
8	3951	7.1%
3	3951	7.1%
4	3951	7.1%
Other values (4)	15804	28.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3951	7.1%
2	3951	7.1%
3	3951	7.1%
4	3951	7.1%
5	3951	7.1%
6	3951	7.1%
7	3951	7.1%
8	3951	7.1%
9	3951	7.1%
10	3951	7.1%

Value	Count	Frequency (%)
14	3951	7.1%
13	3951	7.1%
12	3951	7.1%
11	3951	7.1%
10	3951	7.1%
9	3951	7.1%
8	3951	7.1%
7	3951	7.1%
6	3951	7.1%
5	3951	7.1%

continent
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	432.3 KiB

Europe	22468
Asia	22114
South America	5408
Africa	3030
North America	2045
Other values (2)	249

Length

Max length	13
Median length	7
Mean length	6.1480999
Min length	4

Characters and Unicode

Total characters	340076
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Europe
2nd row	Asia
3rd row	Europe
4th row	Asia
5th row	Europe

Common Values

Value	Count	Frequency (%)
Europe	22468	40.6%
Asia	22114	40.0%
South America	5408	9.8%
Africa	3030	5.5%
North America	2045	3.7%
Oceania	218	0.4%
Unknown	31	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
europe	22468	35.8%
asia	22114	35.2%
america	7453	11.9%
south	5408	8.6%
africa	3030	4.8%
north	2045	3.3%
oceania	218	0.3%
unknown	31	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
r	34996	10.3%
a	33033	9.7%
i	32815	9.6%
A	32597	9.6%
e	30139	8.9%
o	29952	8.8%
u	27876	8.2%
E	22468	6.6%
p	22468	6.6%
s	22114	6.5%
Other values (13)	51618	15.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	269856	79.4%
Uppercase Letter	62767	18.5%
Space Separator	7453	2.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	34996	13.0%
a	33033	12.2%
i	32815	12.2%
e	30139	11.2%
o	29952	11.1%
u	27876	10.3%
p	22468	8.3%
s	22114	8.2%
c	10701	4.0%
m	7453	2.8%
Other values (6)	18309	6.8%

Uppercase Letter

Value	Count	Frequency (%)
A	32597	51.9%
E	22468	35.8%
S	5408	8.6%
N	2045	3.3%
O	218	0.3%
U	31	< 0.1%

Space Separator

Value	Count	Frequency (%)
	7453	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	332623	97.8%
Common	7453	2.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	34996	10.5%
a	33033	9.9%
i	32815	9.9%
A	32597	9.8%
e	30139	9.1%
o	29952	9.0%
u	27876	8.4%
E	22468	6.8%
p	22468	6.8%
s	22114	6.6%
Other values (12)	44165	13.3%

Common

Value	Count	Frequency (%)
	7453	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	340076	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	34996	10.3%
a	33033	9.7%
i	32815	9.6%
A	32597	9.6%
e	30139	8.9%
o	29952	8.8%
u	27876	8.2%
E	22468	6.6%
p	22468	6.6%
s	22114	6.5%
Other values (13)	51618	15.2%

Auto

Heatmap
Table

	club_id	league_id	cohort_season	avg_age_top_11_players	avg_stars_top_11_players	avg_stars_top_14_players	avg_training_factor_top_11_players	days_active_last_28_days	league_match_watched_count_last_28_days	session_count_last_28_days	playtime_last_28_days	league_match_won_count_last_28_days	training_count_last_28_days	global_competition_level	tokens_spent_last_28_days	tokens_stash	rests_stash	morale_boosters_stash	league_rank	dynamic_payment_segment	registration_platform_specific	continent
club_id	1.000	-0.724	-0.987	0.003	-0.496	-0.498	-0.107	-0.483	-0.364	-0.415	-0.366	-0.139	-0.385	-0.537	-0.259	-0.197	-0.242	-0.196	0.087	0.255	0.261	0.123
league_id	-0.724	1.000	0.679	-0.099	0.663	0.667	-0.202	0.498	0.365	0.449	0.418	0.017	0.435	0.471	0.376	0.274	0.454	0.354	0.000	0.224	0.218	0.117
cohort_season	-0.987	0.679	1.000	0.019	0.473	0.474	0.139	0.484	0.365	0.416	0.367	0.140	0.385	0.529	0.256	0.184	0.201	0.154	-0.091	0.244	0.321	0.115
avg_age_top_11_players	0.003	-0.099	0.019	1.000	-0.115	-0.110	-0.047	-0.150	-0.155	-0.176	-0.182	-0.170	-0.215	-0.157	-0.191	-0.143	-0.100	-0.144	0.122	0.073	0.057	0.029
avg_stars_top_11_players	-0.496	0.663	0.473	-0.115	1.000	0.998	-0.433	0.746	0.642	0.751	0.742	0.242	0.737	0.580	0.703	0.191	0.204	0.228	-0.311	0.298	0.112	0.084
avg_stars_top_14_players	-0.498	0.667	0.474	-0.110	0.998	1.000	-0.444	0.746	0.643	0.750	0.741	0.238	0.735	0.577	0.698	0.191	0.202	0.224	-0.310	0.302	0.120	0.088
avg_training_factor_top_11_players	-0.107	-0.202	0.139	-0.047	-0.433	-0.444	1.000	-0.261	-0.204	-0.273	-0.289	0.039	-0.218	-0.086	-0.360	0.122	-0.057	-0.058	0.125	0.065	0.029	0.027
days_active_last_28_days	-0.483	0.498	0.484	-0.150	0.746	0.746	-0.261	1.000	0.826	0.969	0.945	0.529	0.890	0.596	0.821	0.102	0.005	0.065	-0.514	0.219	0.095	0.075
league_match_watched_count_last_28_days	-0.364	0.365	0.365	-0.155	0.642	0.643	-0.204	0.826	1.000	0.863	0.862	0.548	0.801	0.537	0.728	0.073	-0.060	0.019	-0.511	0.203	0.051	0.040
session_count_last_28_days	-0.415	0.449	0.416	-0.176	0.751	0.750	-0.273	0.969	0.863	1.000	0.979	0.554	0.914	0.601	0.848	0.087	-0.016	0.063	-0.539	0.181	0.033	0.031
playtime_last_28_days	-0.366	0.418	0.367	-0.182	0.742	0.741	-0.289	0.945	0.862	0.979	1.000	0.542	0.925	0.589	0.863	0.060	-0.047	0.037	-0.540	0.131	0.029	0.009
league_match_won_count_last_28_days	-0.139	0.017	0.140	-0.170	0.242	0.238	0.039	0.529	0.548	0.554	0.542	1.000	0.520	0.375	0.465	-0.023	-0.184	-0.019	-0.464	0.141	0.043	0.021
training_count_last_28_days	-0.385	0.435	0.385	-0.215	0.737	0.735	-0.218	0.890	0.801	0.914	0.925	0.520	1.000	0.597	0.821	0.102	-0.034	0.058	-0.508	0.053	0.016	0.000
global_competition_level	-0.537	0.471	0.529	-0.157	0.580	0.577	-0.086	0.596	0.537	0.601	0.589	0.375	0.597	1.000	0.522	0.108	0.069	0.158	-0.300	0.197	0.063	0.064
tokens_spent_last_28_days	-0.259	0.376	0.256	-0.191	0.703	0.698	-0.360	0.821	0.728	0.848	0.863	0.465	0.821	0.522	1.000	-0.003	-0.032	0.059	-0.475	0.072	0.009	0.000
tokens_stash	-0.197	0.274	0.184	-0.143	0.191	0.191	0.122	0.102	0.073	0.087	0.060	-0.023	0.102	0.108	-0.003	1.000	0.483	0.371	0.004	0.042	0.025	0.000
rests_stash	-0.242	0.454	0.201	-0.100	0.204	0.202	-0.057	0.005	-0.060	-0.016	-0.047	-0.184	-0.034	0.069	-0.032	0.483	1.000	0.678	0.146	0.044	0.056	0.017
morale_boosters_stash	-0.196	0.354	0.154	-0.144	0.228	0.224	-0.058	0.065	0.019	0.063	0.037	-0.019	0.058	0.158	0.059	0.371	0.678	1.000	0.046	0.054	0.049	0.015
league_rank	0.087	0.000	-0.091	0.122	-0.311	-0.310	0.125	-0.514	-0.511	-0.539	-0.540	-0.464	-0.508	-0.300	-0.475	0.004	0.146	0.046	1.000	0.112	0.023	0.011
dynamic_payment_segment	0.255	0.224	0.244	0.073	0.298	0.302	0.065	0.219	0.203	0.181	0.131	0.141	0.053	0.197	0.072	0.042	0.044	0.054	0.112	1.000	0.180	0.102
registration_platform_specific	0.261	0.218	0.321	0.057	0.112	0.120	0.029	0.095	0.051	0.033	0.029	0.043	0.016	0.063	0.009	0.025	0.056	0.049	0.023	0.180	1.000	0.126
continent	0.123	0.117	0.115	0.029	0.084	0.088	0.027	0.075	0.040	0.031	0.009	0.021	0.000	0.064	0.000	0.000	0.017	0.015	0.011	0.102	0.126	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	season	club_id	league_id	dynamic_payment_segment	cohort_season	avg_age_top_11_players	avg_stars_top_11_players	avg_stars_top_14_players	avg_training_factor_top_11_players	days_active_last_28_days	league_match_watched_count_last_28_days	session_count_last_28_days	playtime_last_28_days	registration_country	registration_platform_specific	league_match_won_count_last_28_days	training_count_last_28_days	global_competition_level	tokens_spent_last_28_days	tokens_stash	rests_stash	morale_boosters_stash	league_rank	continent
0	173	6042825	2912348	2) Minnow	134	25	5.255151	4.483009	1.778801	25	10	271	81281642	Portugal	Flash FB Canvas	24	435	11	598	245	186	818	2	Europe
1	173	9620967	2912140	2) Minnow	28	23	4.962521	4.785648	-0.002687	28	9	119	58448442	Turkey	Android Phone	19	58	7	269	0	35	24	2	Asia
2	173	6045474	2912933	4) Whale	136	23	11.105782	10.511133	0.628794	28	22	210	134640047	Belgium	Flash FB Canvas	26	116	8	23180	369	444	4933	1	Europe
3	173	14187773	2910371	0) NonPayer	2	21	4.164848	4.023486	0.551904	12	0	18	12143308	Malaysia	Android Phone	11	22	2	41	43	213	126	6	Asia
4	173	13694853	2907632	0) NonPayer	5	22	3.031939	2.926029	0.690544	0	0	0	0	Italy	iOS Phone	9	0	4	0	16	100	147	10	Europe
5	173	5990762	2912548	0) NonPayer	104	23	5.165491	5.014962	0.508691	28	6	113	52316063	Italy	iOS Phone	18	66	3	117	32	52	28	2	Europe
6	173	14223642	2911299	2) Minnow	2	23	5.331697	5.165514	0.260603	25	11	176	115438831	Cambodia	iOS Phone	21	105	6	313	19	48	27	2	Asia
7	173	11709507	2910371	0) NonPayer	16	24	3.881236	3.727657	0.587786	1	1	1	2438713	Indonesia	Android Phone	12	2	0	9	25	97	181	12	Asia
8	173	14492950	2905919	0) NonPayer	1	27	4.307879	4.078724	0.442616	7	5	25	15506003	Algeria	Android Phone	6	22	1	78	4	6	66	7	Africa
9	173	14436853	2906383	0) NonPayer	1	22	3.757782	3.536762	0.611114	3	0	9	5814384	Spain	Android Phone	14	12	0	47	39	31	66	5	Europe

	season	club_id	league_id	dynamic_payment_segment	cohort_season	avg_age_top_11_players	avg_stars_top_11_players	avg_stars_top_14_players	avg_training_factor_top_11_players	days_active_last_28_days	league_match_watched_count_last_28_days	session_count_last_28_days	playtime_last_28_days	registration_country	registration_platform_specific	league_match_won_count_last_28_days	training_count_last_28_days	global_competition_level	tokens_spent_last_28_days	tokens_stash	rests_stash	morale_boosters_stash	league_rank	continent
55304	173	14288471	2907355	2) Minnow	2	25	4.679042	4.612371	0.439115	26	5	142	108773302	Brazil	Android Phone	24	54	1	147	4	23	7	2	South America
55305	173	12376486	2912392	0) NonPayer	11	25	4.806133	4.643391	0.489918	28	10	162	64578060	Jordan	Android Phone	17	81	1	52	28	17	10	4	Asia
55306	173	14335735	2908747	0) NonPayer	1	23	4.565115	4.446571	0.421821	3	0	5	2171933	France	iOS Tablet	2	9	0	90	40	279	225	5	Europe
55307	173	14390385	2908404	0) NonPayer	1	23	4.898182	4.759543	0.414504	10	2	47	20124926	Egypt	Android Phone	11	60	1	135	8	8	195	5	Africa
55308	173	13830216	2910758	0) NonPayer	4	25	4.470218	4.167733	0.323581	0	0	0	0	France	iOS Phone	4	0	0	0	18	1016	38	7	Europe
55309	173	14278145	2906514	0) NonPayer	2	25	4.160909	3.948086	0.503241	11	2	28	18536739	Switzerland	iOS Phone	13	25	0	42	10	25	37	1	Europe
55310	173	14309556	2906913	2) Minnow	2	21	4.244145	3.762286	0.664514	28	25	383	319296693	France	iOS Phone	25	167	0	214	158	358	256	1	Europe
55311	173	14455654	2905985	0) NonPayer	1	21	4.000158	3.753276	0.507620	6	2	27	10648296	France	iOS Tablet	14	17	0	73	11	70	57	11	Europe
55312	173	13623733	2910437	0) NonPayer	5	24	4.582158	4.461391	0.664767	28	13	121	70077991	Morocco	Android Phone	22	80	4	90	65	109	150	5	Africa
55313	173	11719971	2910381	0) NonPayer	16	23	5.176582	4.762305	0.640298	1	0	1	604376	Greece	Android Phone	6	2	6	50	24	17	354	9	Europe

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions